AutoRepublish Warning Alert should be enabled

AutoRepublish Warning Alert should be enabled - Excel

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-17744	DTOO141 - Excel	SV-18928r1_rule	ECSC-1	Medium

Description
AutoRepublish is a feature in Excel 2007 that allows workbooks to be automatically republished to the World Wide Web each time the workbook is saved. A number of changes might need to be made to allow the workbook to be successfully published, including the following: • External references are converted to values. • Hidden formulas become visible. • The Set precision as displayed option, which appears beneath the When calculating this workbook heading in the Advanced section of the Excel Options dialog box, is no longer available. These types of changes can mean that the version on the Web page might not be the same as the Excel file. By default, a message dialog box appears every time the user saves a published workbook when AutoRepublish is enabled. From this dialog box, the user can disable AutoRepublish temporarily or permanently, or select Do not show this message again to prevent the dialog box from appearing after every save. If the user selects Do not show this message again, Excel will continue to automatically republish the data after every save without informing the user.

Description

AutoRepublish is a feature in Excel 2007 that allows workbooks to be automatically republished to the World Wide Web each time the workbook is saved. A number of changes might need to be made to allow the workbook to be successfully published, including the following: • External references are converted to values. • Hidden formulas become visible. • The Set precision as displayed option, which appears beneath the When calculating this workbook heading in the Advanced section of the Excel Options dialog box, is no longer available. These types of changes can mean that the version on the Web page might not be the same as the Excel file. By default, a message dialog box appears every time the user saves a published workbook when AutoRepublish is enabled. From this dialog box, the user can disable AutoRepublish temporarily or permanently, or select Do not show this message again to prevent the dialog box from appearing after every save. If the user selects Do not show this message again, Excel will continue to automatically republish the data after every save without informing the user.

STIG	Date
Microsoft Excel 2007	2015-10-02

Details

Check Text ( C-19006r1_chk )
The policy value for User Configuration -> Administrative Templates -> Microsoft Office Excel 2007 -> Excel Options -> Save “AutoRepublish Warning Alert” will be set to “Enabled (Always show the alert before publishing)”. Procedure: Use the Windows Registry Editor to navigate to the following key: HKCU\Software\Policies\Microsoft\Office\12.0\Excel\Options Criteria: If the value DisableAutoRepublishWarning is REG_DWORD = 0, this is not a finding.

Check Text ( C-19006r1_chk )

The policy value for User Configuration -> Administrative Templates -> Microsoft Office Excel 2007 -> Excel Options -> Save “AutoRepublish Warning Alert” will be set to “Enabled (Always show the alert before publishing)”.

Procedure: Use the Windows Registry Editor to navigate to the following key:

HKCU\Software\Policies\Microsoft\Office\12.0\Excel\Options

Criteria: If the value DisableAutoRepublishWarning is REG_DWORD = 0, this is not a finding.

Fix Text (F-17643r1_fix)
The policy value for User Configuration -> Administrative Templates -> Microsoft Office Excel 2007 -> Excel Options -> Save “AutoRepublish Warning Alert” will be set to “Enabled (Always show the alert before publishing)”.